[dbo].[BAECartEventFunctionGetAllForEvent]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAECartEventFunctionGetAllForEvent
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@Id
int
4
SQL Script
create
procedure
[dbo]
.
[BAECartEventFunctionGetAllForEvent]
@Id
int
as
SELECT
cef.
*
FROM
CartEventFunction
cef
INNER
JOIN
CartEvent
ce
on
ce.CartEventID
=
cef.CartEventID
WHERE
ce.CartEventID
=
@Id
GO
Uses
[dbo].[CartEvent]
[dbo].[CartEventFunction]
dbo